﻿CREATE TABLE [dbo].[onco_SchemaInternare] (
    [IDSchema]        INT           IDENTITY (1, 1) NOT NULL,
    [IDProtocol]      SMALLINT      NOT NULL,
    [Ziua]            SMALLINT      CONSTRAINT [DF_onco_SchemaInternare_Ziua] DEFAULT ((1)) NOT NULL,
    [ZiuaCiclu2]      SMALLINT      NULL,
    [IDCitostatic]    SMALLINT      NOT NULL,
    [Doza]            FLOAT (53)    NOT NULL,
    [Explicatie]      VARCHAR (250) CONSTRAINT [DF_onco_SchemaInternare_Explicatie2] DEFAULT ('') NOT NULL,
    [IDInternare]     INT           NOT NULL,
    [DozaRecomandata] FLOAT (53)    CONSTRAINT [DF_onco_SchemaInternare_DozaRecomandata] DEFAULT ((0)) NOT NULL,
    [DozaPrescrisa]   FLOAT (53)    CONSTRAINT [DF_onco_SchemaInternare_DozaPrescrisa] DEFAULT ((0)) NOT NULL,
    [UM]              VARCHAR (50)  NULL,
    CONSTRAINT [PK_onco_SchemaInternare] PRIMARY KEY CLUSTERED ([IDSchema] ASC),
    CONSTRAINT [FK_onco_SchemaInternare_Internare] FOREIGN KEY ([IDInternare]) REFERENCES [dbo].[Internare] ([IDInternare]),
    CONSTRAINT [FK_onco_SchemaInternare_onco_Citostatice] FOREIGN KEY ([IDCitostatic]) REFERENCES [dbo].[onco_Citostatice] ([IDCitostatic]),
    CONSTRAINT [FK_onco_SchemaInternare_onco_Protocoale] FOREIGN KEY ([IDProtocol]) REFERENCES [dbo].[onco_Protocoale] ([IDProtocol])
);

